{
  "statement":"select  i_product_name\n             ,i_brand\n             ,i_class\n             ,i_category\n             ,avg(inv_quantity_on_hand) qoh\n       from inventory\n           ,date_dim\n           ,item\n       where inv_date_sk\u003dd_date_sk\n              and inv_item_sk\u003di_item_sk\n              and d_month_seq between 1200 and 1200 + 11\n       group by rollup(i_product_name\n                       ,i_brand\n                       ,i_class\n                       ,i_category)\norder by qoh, i_product_name, i_brand, i_class, i_category\nlimit 100;\n",
  "table_meta":{
    "tpcds.item":"CREATE TABLE `item` (\n  `i_item_sk` int(11) NOT NULL COMMENT \"\",\n  `i_item_id` char(16) NOT NULL COMMENT \"\",\n  `i_rec_start_date` date NULL COMMENT \"\",\n  `i_rec_end_date` date NULL COMMENT \"\",\n  `i_item_desc` varchar(200) NULL COMMENT \"\",\n  `i_current_price` decimal64(7, 2) NULL COMMENT \"\",\n  `i_wholesale_cost` decimal64(7, 2) NULL COMMENT \"\",\n  `i_brand_id` int(11) NULL COMMENT \"\",\n  `i_brand` char(50) NULL COMMENT \"\",\n  `i_class_id` int(11) NULL COMMENT \"\",\n  `i_class` char(50) NULL COMMENT \"\",\n  `i_category_id` int(11) NULL COMMENT \"\",\n  `i_category` char(50) NULL COMMENT \"\",\n  `i_manufact_id` int(11) NULL COMMENT \"\",\n  `i_manufact` char(50) NULL COMMENT \"\",\n  `i_size` char(20) NULL COMMENT \"\",\n  `i_formulation` char(20) NULL COMMENT \"\",\n  `i_color` char(20) NULL COMMENT \"\",\n  `i_units` char(10) NULL COMMENT \"\",\n  `i_container` char(10) NULL COMMENT \"\",\n  `i_manager_id` int(11) NULL COMMENT \"\",\n  `i_product_name` char(50) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`i_item_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`i_item_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.inventory":"CREATE TABLE `inventory` (\n  `inv_date_sk` int(11) NOT NULL COMMENT \"\",\n  `inv_item_sk` int(11) NOT NULL COMMENT \"\",\n  `inv_warehouse_sk` int(11) NOT NULL COMMENT \"\",\n  `inv_quantity_on_hand` int(11) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`inv_date_sk`, `inv_item_sk`, `inv_warehouse_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`inv_date_sk`, `inv_item_sk`, `inv_warehouse_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);",
    "tpcds.date_dim":"CREATE TABLE `date_dim` (\n  `d_date_sk` int(11) NOT NULL COMMENT \"\",\n  `d_date_id` char(16) NOT NULL COMMENT \"\",\n  `d_date` date NULL COMMENT \"\",\n  `d_month_seq` int(11) NULL COMMENT \"\",\n  `d_week_seq` int(11) NULL COMMENT \"\",\n  `d_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_year` int(11) NULL COMMENT \"\",\n  `d_dow` int(11) NULL COMMENT \"\",\n  `d_moy` int(11) NULL COMMENT \"\",\n  `d_dom` int(11) NULL COMMENT \"\",\n  `d_qoy` int(11) NULL COMMENT \"\",\n  `d_fy_year` int(11) NULL COMMENT \"\",\n  `d_fy_quarter_seq` int(11) NULL COMMENT \"\",\n  `d_fy_week_seq` int(11) NULL COMMENT \"\",\n  `d_day_name` char(9) NULL COMMENT \"\",\n  `d_quarter_name` char(6) NULL COMMENT \"\",\n  `d_holiday` char(1) NULL COMMENT \"\",\n  `d_weekend` char(1) NULL COMMENT \"\",\n  `d_following_holiday` char(1) NULL COMMENT \"\",\n  `d_first_dom` int(11) NULL COMMENT \"\",\n  `d_last_dom` int(11) NULL COMMENT \"\",\n  `d_same_day_ly` int(11) NULL COMMENT \"\",\n  `d_same_day_lq` int(11) NULL COMMENT \"\",\n  `d_current_day` char(1) NULL COMMENT \"\",\n  `d_current_week` char(1) NULL COMMENT \"\",\n  `d_current_month` char(1) NULL COMMENT \"\",\n  `d_current_quarter` char(1) NULL COMMENT \"\",\n  `d_current_year` char(1) NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`d_date_sk`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`d_date_sk`) BUCKETS 5 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\"\n);"
  },
  "table_row_count":{
    "tpcds.inventory":{
      "inventory":399330000
    },
    "tpcds.item":{
      "item":204000
    },
    "tpcds.date_dim":{
      "date_dim":73049
    }
  },
  "session_variables":"{\"runtime_join_filter_push_down_limit\":2048000,\"codegen_level\":0,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":true,\"div_precision_increment\":4,\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"auto_increment_increment\":1,\"foreign_key_checks\":true,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"character_set_results\":\"utf8\",\"parallel_fragment_exec_instance_num\":24,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":false,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"prefer_join_method\":\"broadcast\",\"load_mem_limit\":0,\"sql_select_limit\":9223372036854775807,\"profiling\":false,\"sql_safe_updates\":0,\"enable_pipeline_engine\":false,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"enable_vectorized_engine\":true,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"normal\",\"enable_new_planner_push_down_join_to_agg\":false,\"broadcast_row_limit\":15000000,\"exec_mem_limit\":32212254720,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"enable_vectorized_insert\":true,\"interactive_timeout\":3600,\"enable_spilling\":false,\"batch_size\":1024,\"cbo_enable_replicated_join\":true,\"max_allowed_packet\":1048576,\"query_timeout\":300,\"enable_cbo\":true,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"max_execution_time\":3000000,\"character_set_server\":\"utf8\",\"cbo_use_nth_exec_plan\":0,\"rewrite_count_distinct_to_bitmap_hll\":true,\"parallel_exchange_instance_num\":-1,\"sql_mode\":34,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false}",
  "column_statistics":{
    "tpcds.inventory":{
      "inv_date_sk":"[2450815.0, 2452635.0, 0.0, 4.0, 260.0]",
      "inv_quantity_on_hand":"[0.0, 1000.0, 0.05000724964315228, 4.0, 1006.0]",
      "inv_item_sk":"[1.0, 204000.0, 0.0, 4.0, 200414.0]"
    },
    "tpcds.item":{
      "i_class":"[-Infinity, Infinity, 0.002446078431372549, 7.774200980392157, 99.0]",
      "i_category":"[-Infinity, Infinity, 0.0023627450980392155, 5.890700980392157, 10.0]",
      "i_brand":"[-Infinity, Infinity, 0.0025, 16.11603431372549, 713.0]",
      "i_product_name":"[-Infinity, Infinity, 0.002519607843137255, 22.285039215686275, 200390.0]",
      "i_item_sk":"[1.0, 204000.0, 0.0, 4.0, 200414.0]"
    },
    "tpcds.date_dim":{
      "d_month_seq":"[0.0, 2400.0, 0.0, 4.0, 2398.0]",
      "d_date_sk":"[2415022.0, 2488070.0, 0.0, 4.0, 72542.0]"
    }
  },
  "be_number":5,
  "exception":[

  ]
}
